<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">

	<title>Interface ManaPHP\DbInterface</title>

	<link rel="stylesheet" href="resources/style.css?c2f33731c1948fbed7c333554678bfa68d4817da">

</head>

<body>
<div id="left">
	<div id="menu">
		<a href="index.html" title="Overview"><span>Overview</span></a>


		<div id="groups">
				<h3>Namespaces</h3>
			<ul>
				<li class="active">
					<a href="namespace-ManaPHP.html">
						ManaPHP<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Alias.html">
						Alias					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Authentication.html">
						Authentication<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Authentication.Token.html">
						Token<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Authentication.Token.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Authentication.Token.Adapter.Mwt.html">
						Mwt					</a>

						</li>
							</ul></li></ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Authorization.html">
						Authorization<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Authorization.Rbac.html">
						Rbac<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Authorization.Rbac.Models.html">
						Models					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Authorization.Rbac.PermissionBuilder.html">
						PermissionBuilder					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Cache.html">
						Cache<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Cache.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Cache.Adapter.Apc.html">
						Apc					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Cache.Adapter.Db.html">
						Db					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Cache.Adapter.File.html">
						File					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Cli.html">
						Cli<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Cli.Application.html">
						Application					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Cli.Arguments.html">
						Arguments					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Cli.Controllers.html">
						Controllers					</a>

						</li>
							</ul></li>
				<li>
					<a href="namespace-ManaPHP.Component.html">
						Component					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Configure.html">
						Configure<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Configure.Engine.html">
						Engine<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Configure.Engine.Ini.html">
						Ini					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Configure.Engine.Json.html">
						Json					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Counter.html">
						Counter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Counter.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Counter.Adapter.Db.html">
						Db					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Db.html">
						Db<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Db.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Db.Adapter.Sqlite.html">
						Sqlite					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Debugger.html">
						Debugger					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Di.html">
						Di					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Event.html">
						Event<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Event.Manager.html">
						Manager					</a>

						</li>
							</ul></li>
				<li>
					<a href="namespace-ManaPHP.Facade.html">
						Facade					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Filesystem.html">
						Filesystem<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Filesystem.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Filesystem.Adapter.File.html">
						File					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Http.html">
						Http<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Http.Client.html">
						Client					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Http.Cookies.html">
						Cookies					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Http.Filter.html">
						Filter					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Http.Request.html">
						Request<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Http.Request.File.html">
						File					</a>

						</li>
							</ul></li>
				<li>
					<a href="namespace-ManaPHP.Http.Response.html">
						Response					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Http.Session.html">
						Session<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Http.Session.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Http.Session.Adapter.Db.html">
						Db					</a>

						</li>
							</ul></li></ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.I18n.html">
						I18n					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Image.html">
						Image<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Image.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Image.Adapter.Gd.html">
						Gd					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Image.Adapter.Imagick.html">
						Imagick					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Loader.html">
						Loader					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Logger.html">
						Logger<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Logger.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Logger.Adapter.Db.html">
						Db					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Message.html">
						Message<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Message.Queue.html">
						Queue<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Message.Queue.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Message.Queue.Adapter.Db.html">
						Db					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Message.Queue.Adapter.Redis.html">
						Redis					</a>

						</li>
							</ul></li></ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Meter.html">
						Meter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Meter.Linear.html">
						Linear					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Meter.Round.html">
						Round					</a>

						</li>
							</ul></li>
				<li>
					<a href="namespace-ManaPHP.Mvc.html">
						Mvc<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Mvc.Application.html">
						Application					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Mvc.Dispatcher.html">
						Dispatcher					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Mvc.Model.html">
						Model<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Mvc.Model.Manager.html">
						Manager					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Mvc.Model.Metadata.html">
						Metadata<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Mvc.Model.Metadata.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Mvc.Model.Metadata.Adapter.Apc.html">
						Apc					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Mvc.Model.QueryBuilder.html">
						QueryBuilder					</a>

						</li>
							</ul></li>
				<li>
					<a href="namespace-ManaPHP.Mvc.Router.html">
						Router<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Mvc.Router.RewriteChecker.html">
						RewriteChecker					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Mvc.Router.Route.html">
						Route					</a>

						</li>
							</ul></li>
				<li>
					<a href="namespace-ManaPHP.Mvc.Url.html">
						Url					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Mvc.User.html">
						User					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Mvc.View.html">
						View<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Mvc.View.Flash.html">
						Flash<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Mvc.View.Flash.Adapter.html">
						Adapter					</a>

						</li>
							</ul></li></ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Paginator.html">
						Paginator					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Renderer.html">
						Renderer<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Renderer.Engine.html">
						Engine<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Renderer.Engine.Php.html">
						Php					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Renderer.Engine.Sword.html">
						Sword					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Security.html">
						Security<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Security.Captcha.html">
						Captcha					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Security.Crypt.html">
						Crypt					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Security.CsrfToken.html">
						CsrfToken					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Security.RateLimiter.html">
						RateLimiter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Security.RateLimiter.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Security.RateLimiter.Adapter.Db.html">
						Db					</a>

						</li>
							</ul></li></ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Serializer.html">
						Serializer<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Serializer.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Serializer.Adapter.Json.html">
						Json					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Serializer.Adapter.JsonPhp.html">
						JsonPhp					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Serializer.Adapter.Php.html">
						Php					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Serializer.Adapter.StringType.html">
						StringType					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Store.html">
						Store<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Store.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Store.Adapter.Db.html">
						Db					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Store.Adapter.File.html">
						File					</a>

						</li>
							</ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Task.html">
						Task<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Task.Metadata.html">
						Metadata<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Task.Metadata.Adapter.html">
						Adapter<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-ManaPHP.Task.Metadata.Adapter.Apc.html">
						Apc					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Task.Metadata.Adapter.Db.html">
						Db					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Task.Metadata.Adapter.Redis.html">
						Redis					</a>

						</li>
							</ul></li></ul></li></ul></li>
				<li>
					<a href="namespace-ManaPHP.Text.html">
						Text					</a>

						</li>
				<li>
					<a href="namespace-ManaPHP.Utility.html">
						Utility					</a>

						</li>
							</ul></li>
			</ul>
		</div>

		<hr>


		<div id="elements">
			<h3>Classes</h3>
			<ul>
				<li><a href="class-ManaPHP.Alias.html">Alias</a></li>
				<li><a href="class-ManaPHP.Application.html">Application</a></li>
				<li><a href="class-ManaPHP.Cache.html">Cache</a></li>
				<li><a href="class-ManaPHP.Component.html">Component</a></li>
				<li><a href="class-ManaPHP.Configure.html">Configure</a></li>
				<li><a href="class-ManaPHP.Counter.html">Counter</a></li>
				<li><a href="class-ManaPHP.Db.html">Db</a></li>
				<li><a href="class-ManaPHP.Debugger.html">Debugger</a></li>
				<li><a href="class-ManaPHP.Di.html">Di</a></li>
				<li><a href="class-ManaPHP.Facade.html">Facade</a></li>
				<li><a href="class-ManaPHP.Image.html">Image</a></li>
				<li><a href="class-ManaPHP.Loader.html">Loader</a></li>
				<li><a href="class-ManaPHP.Logger.html">Logger</a></li>
				<li><a href="class-ManaPHP.Paginator.html">Paginator</a></li>
				<li><a href="class-ManaPHP.Renderer.html">Renderer</a></li>
				<li><a href="class-ManaPHP.Store.html">Store</a></li>
				<li><a href="class-ManaPHP.Task.html">Task</a></li>
				<li><a href="class-ManaPHP.Version.html">Version</a></li>
			</ul>

			<h3>Interfaces</h3>
			<ul>
				<li><a href="class-ManaPHP.AliasInterface.html">AliasInterface</a></li>
				<li><a href="class-ManaPHP.ApplicationInterface.html">ApplicationInterface</a></li>
				<li><a href="class-ManaPHP.AuthorizationInterface.html">AuthorizationInterface</a></li>
				<li><a href="class-ManaPHP.CacheInterface.html">CacheInterface</a></li>
				<li><a href="class-ManaPHP.ComponentInterface.html">ComponentInterface</a></li>
				<li><a href="class-ManaPHP.ConfigureInterface.html">ConfigureInterface</a></li>
				<li><a href="class-ManaPHP.CounterInterface.html">CounterInterface</a></li>
				<li class="active"><a href="class-ManaPHP.DbInterface.html">DbInterface</a></li>
				<li><a href="class-ManaPHP.DebuggerInterface.html">DebuggerInterface</a></li>
				<li><a href="class-ManaPHP.DiInterface.html">DiInterface</a></li>
				<li><a href="class-ManaPHP.FilesystemInterface.html">FilesystemInterface</a></li>
				<li><a href="class-ManaPHP.ImageInterface.html">ImageInterface</a></li>
				<li><a href="class-ManaPHP.LoaderInterface.html">LoaderInterface</a></li>
				<li><a href="class-ManaPHP.LoggerInterface.html">LoggerInterface</a></li>
				<li><a href="class-ManaPHP.PaginatorInterface.html">PaginatorInterface</a></li>
				<li><a href="class-ManaPHP.RendererInterface.html">RendererInterface</a></li>
				<li><a href="class-ManaPHP.StoreInterface.html">StoreInterface</a></li>
				<li><a href="class-ManaPHP.TaskInterface.html">TaskInterface</a></li>
			</ul>


			<h3>Exceptions</h3>
			<ul>
				<li><a href="class-ManaPHP.Exception.html">Exception</a></li>
			</ul>


		</div>
	</div>
</div>

<div id="splitter"></div>

<div id="right">
<div id="rightInner">
	<form id="search">
		<input type="hidden" name="cx" value="">
		<input type="hidden" name="ie" value="UTF-8">
		<input type="text" name="q" class="text" placeholder="Search">
	</form>

	<div id="navigation">
		<ul>
			<li>
				<a href="index.html" title="Overview"><span>Overview</span></a>
			</li>
			<li>
				<a href="namespace-ManaPHP.html" title="Summary of ManaPHP"><span>Namespace</span></a>
			</li>
			<li class="active">
<span>Class</span>			</li>
		</ul>
		<ul>
		</ul>
		<ul>
		</ul>
	</div>

<div id="content" class="class">
	<h1>Interface DbInterface</h1>


	<div class="description">
	<p>Interface ManaPHP\DbInterface</p>
	</div>





	<div>
		<h4>Direct known implementers</h4>
			<a href="class-ManaPHP.Db.html">ManaPHP\Db</a>
	</div>

	<div>
		<h4>Indirect known implementers</h4>
			<a href="class-ManaPHP.Db.Adapter.Mysql.html">ManaPHP\Db\Adapter\Mysql</a>, 
			<a href="class-ManaPHP.Db.Adapter.Sqlite.html">ManaPHP\Db\Adapter\Sqlite</a>
	</div>



	<div class="info">
		
		
		<b>Namespace:</b> <a href="namespace-ManaPHP.html">ManaPHP</a><br>
		<b>Package:</b> db<br>

			<b>Located at</b> <a href="source-class-ManaPHP.DbInterface.html#5-227" title="Go to source code">DbInterface.php</a>
		<br>
	</div>



	<table class="summary methods" id="methods">
	<caption>Methods summary</caption>
	<tr data-order="fetchOne" id="_fetchOne">

		<td class="attributes"><code>
			 public 

			array|false
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_fetchOne">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#13-27" title="Go to source code">fetchOne</a>( <span>string <var>$sql</var></span>, <span>array <var>$bind</var> = []</span>, <span>integer <var>$fetchMode</var> = \PDO::FETCH_ASSOC</span> )</code>

		<div class="description short">
			<p>Returns the first row in a SQL query result</p>
		</div>

		<div class="description detailed hidden">
			<p>Returns the first row in a SQL query result</p>

<pre><span class="php-var">$db</span>-&gt;fetchOne(<span class="php-quote">'SELECT * FROM city'</span>);
 <span class="php-var">$db</span>-&gt;fetchOne(<span class="php-quote">'SELECT * FROM city WHERE city_id =:city_id'</span>,[<span class="php-quote">'city_id'</span>=&gt;<span class="php-num">5</span>]);</pre>


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$sql</var></dt>
					<dd></dd>
					<dt><var>$bind</var></dt>
					<dd></dd>
					<dt><var>$fetchMode</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					array|false
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="fetchAll" id="_fetchAll">

		<td class="attributes"><code>
			 public 

			array
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_fetchAll">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#29-43" title="Go to source code">fetchAll</a>( <span>string <var>$sql</var></span>, <span>array <var>$bind</var> = []</span>, <span>integer <var>$fetchMode</var> = \PDO::FETCH_ASSOC</span> )</code>

		<div class="description short">
			<p>Dumps the complete result of a query into an array</p>
		</div>

		<div class="description detailed hidden">
			<p>Dumps the complete result of a query into an array</p>

<pre><span class="php-var">$db</span>-&gt;fetchAll(<span class="php-quote">'SELECT * FROM city'</span>);
 <span class="php-var">$db</span>-&gt;fetchAll(<span class="php-quote">'SELECT * FROM city WHERE city_id &lt;:city_id'</span>,[<span class="php-quote">'city_id'</span>=&gt;<span class="php-num">5</span>]);</pre>


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$sql</var></dt>
					<dd></dd>
					<dt><var>$bind</var></dt>
					<dd></dd>
					<dt><var>$fetchMode</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					array
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="insert" id="_insert">

		<td class="attributes"><code>
			 public 

			
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_insert">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#45-58" title="Go to source code">insert</a>( <span>string <var>$table</var></span>, <span>array <var>$columnValues</var></span> )</code>

		<div class="description short">
			<p>Inserts data into a table using custom SQL syntax</p>
		</div>

		<div class="description detailed hidden">
			<p>Inserts data into a table using custom SQL syntax</p>

<pre><span class="php-var">$db</span>-&gt;insert(<span class="php-quote">'_student'</span>,[<span class="php-quote">'age'</span>=&gt;<span class="php-num">30</span>,<span class="php-quote">'name'</span>=&gt;<span class="php-quote">'Mark'</span>]);
 <span class="php-var">$db</span>-&gt;insert(<span class="php-quote">'_student'</span>,[<span class="php-keyword1">null</span>,<span class="php-num">30</span>,<span class="php-quote">'Mark'</span>]);</pre>


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$table</var></dt>
					<dd></dd>
					<dt><var>$columnValues</var></dt>
					<dd></dd>
				</dl></div>





		</div>
		</div></td>
	</tr>
	<tr data-order="update" id="_update">

		<td class="attributes"><code>
			 public 

			integer
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_update">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#60-76" title="Go to source code">update</a>( <span>string <var>$table</var></span>, <span>array <var>$columnValues</var></span>, <span>string|array <var>$conditions</var></span>, <span>array <var>$bind</var> = []</span> )</code>

		<div class="description short">
			<p>Updates data on a table using custom SQL syntax</p>
		</div>

		<div class="description detailed hidden">
			<p>Updates data on a table using custom SQL syntax</p>

<pre><span class="php-var">$db</span>-&gt;update(<span class="php-quote">'_student'</span>,[<span class="php-quote">'name'</span>=&gt;<span class="php-quote">'mark'</span>],<span class="php-quote">'id=2'</span>);
 <span class="php-var">$db</span>-&gt;update(<span class="php-quote">'_student'</span>,[<span class="php-quote">'name'</span>=&gt;<span class="php-quote">'mark'</span>],[<span class="php-quote">'id'</span>=&gt;<span class="php-num">2</span>]);
 <span class="php-var">$db</span>-&gt;update(<span class="php-quote">'_student'</span>,[<span class="php-quote">'name'</span>=&gt;<span class="php-quote">'mark'</span>],<span class="php-quote">'id=:id'</span>,[<span class="php-quote">'id'</span>=&gt;<span class="php-num">2</span>]);</pre>


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$table</var></dt>
					<dd></dd>
					<dt><var>$columnValues</var></dt>
					<dd></dd>
					<dt><var>$conditions</var></dt>
					<dd></dd>
					<dt><var>$bind</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					integer
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="delete" id="_delete">

		<td class="attributes"><code>
			 public 

			integer
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_delete">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#78-94" title="Go to source code">delete</a>( <span>string <var>$table</var></span>, <span>string|array <var>$conditions</var></span>, <span>array <var>$bind</var> = []</span> )</code>

		<div class="description short">
			<p>Deletes data from a table using custom SQL syntax</p>
		</div>

		<div class="description detailed hidden">
			<p>Deletes data from a table using custom SQL syntax</p>

<pre><span class="php-var">$db</span>-&gt;<span class="php-keyword2">delete</span>(<span class="php-quote">'_student'</span>,<span class="php-quote">'id=1'</span>);
 <span class="php-var">$db</span>-&gt;<span class="php-keyword2">delete</span>(<span class="php-quote">'_student'</span>,[<span class="php-quote">'id'</span>=&gt;<span class="php-num">1</span>]);
 <span class="php-var">$db</span>-&gt;<span class="php-keyword2">delete</span>(<span class="php-quote">'_student'</span>,[<span class="php-quote">'id'</span>=&gt;<span class="php-num">1</span>]);
 <span class="php-var">$db</span>-&gt;<span class="php-keyword2">delete</span>(<span class="php-quote">'_student'</span>,<span class="php-quote">'id=:id'</span>,[<span class="php-quote">'id'</span>=&gt;<span class="php-num">1</span>]);</pre>


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$table</var></dt>
					<dd></dd>
					<dt><var>$conditions</var></dt>
					<dd></dd>
					<dt><var>$bind</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					integer
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="limit" id="_limit">

		<td class="attributes"><code>
			 public 

			string
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_limit">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#96-110" title="Go to source code">limit</a>( <span>string <var>$sql</var></span>, <span>integer <var>$number</var></span>, <span>integer <var>$offset</var> = <span class="php-keyword1">null</span></span> )</code>

		<div class="description short">
			<p>Appends a LIMIT clause to $sql argument</p>
		</div>

		<div class="description detailed hidden">
			<p>Appends a LIMIT clause to $sql argument</p>

<pre><span class="php-var">$db</span>-&gt;limit(<span class="php-quote">''</span>,<span class="php-num">10</span>);  <span class="php-comment">//LIMIT 10</span>
 <span class="php-var">$db</span>-&gt;limit(<span class="php-quote">''</span>,<span class="php-num">10</span>,<span class="php-num">100</span>);   <span class="php-comment">//LIMIT 10 OFFSET 100</span></pre>


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$sql</var></dt>
					<dd></dd>
					<dt><var>$number</var></dt>
					<dd></dd>
					<dt><var>$offset</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					string
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="getSQL" id="_getSQL">

		<td class="attributes"><code>
			 public 

			string
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_getSQL">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#112-117" title="Go to source code">getSQL</a>( )</code>

		<div class="description short">
			<p>Active SQL statement in the object</p>
		</div>

		<div class="description detailed hidden">
			<p>Active SQL statement in the object</p>



				<h4>Returns</h4>
				<div class="list">
					string
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="getEmulatedSQL" id="_getEmulatedSQL">

		<td class="attributes"><code>
			 public 

			string
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_getEmulatedSQL">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#119-126" title="Go to source code">getEmulatedSQL</a>( <span>integer <var>$preservedStrLength</var> = -<span class="php-num">1</span></span> )</code>

		<div class="description short">
			<p>Active SQL statement in the object with replace the bind with value</p>
		</div>

		<div class="description detailed hidden">
			<p>Active SQL statement in the object with replace the bind with value</p>


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$preservedStrLength</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					string
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="getBind" id="_getBind">

		<td class="attributes"><code>
			 public 

			array
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_getBind">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#128-133" title="Go to source code">getBind</a>( )</code>

		<div class="description short">
			<p>Active SQL statement in the object</p>
		</div>

		<div class="description detailed hidden">
			<p>Active SQL statement in the object</p>



				<h4>Returns</h4>
				<div class="list">
					array
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="query" id="_query">

		<td class="attributes"><code>
			 public 

			PDOStatement
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_query">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#135-145" title="Go to source code">query</a>( <span>string <var>$sql</var></span>, <span>array <var>$bind</var> = []</span>, <span>integer <var>$fetchMode</var> = \PDO::FETCH_ASSOC</span> )</code>

		<div class="description short">
			<p>Sends SQL statements to the database server returning the success state.
Use this method only when the SQL statement sent to the server return rows</p>
		</div>

		<div class="description detailed hidden">
			<p>Sends SQL statements to the database server returning the success state.
Use this method only when the SQL statement sent to the server return rows</p>


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$sql</var></dt>
					<dd></dd>
					<dt><var>$bind</var></dt>
					<dd></dd>
					<dt><var>$fetchMode</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					PDOStatement
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="execute" id="_execute">

		<td class="attributes"><code>
			 public 

			integer
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_execute">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#147-156" title="Go to source code">execute</a>( <span>string <var>$sql</var></span>, <span>array <var>$bind</var> = []</span> )</code>

		<div class="description short">
			<p>Sends SQL statements to the database server returning the success state.
Use this method only when the SQL statement sent to the server don't return any row</p>
		</div>

		<div class="description detailed hidden">
			<p>Sends SQL statements to the database server returning the success state.
Use this method only when the SQL statement sent to the server don't return any row</p>


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$sql</var></dt>
					<dd></dd>
					<dt><var>$bind</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					integer
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="affectedRows" id="_affectedRows">

		<td class="attributes"><code>
			 public 

			integer
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_affectedRows">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#158-163" title="Go to source code">affectedRows</a>( )</code>

		<div class="description short">
			<p>Returns the number of affected rows by the last INSERT/UPDATE/DELETE reported by the database system</p>
		</div>

		<div class="description detailed hidden">
			<p>Returns the number of affected rows by the last INSERT/UPDATE/DELETE reported by the database system</p>



				<h4>Returns</h4>
				<div class="list">
					integer
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="escapeIdentifier" id="_escapeIdentifier">

		<td class="attributes"><code>
			 public 

			string
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_escapeIdentifier">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#165-172" title="Go to source code">escapeIdentifier</a>( <span>string|array <var>$identifier</var></span> )</code>

		<div class="description short">
			<p>Escapes a column/table/schema name</p>
		</div>

		<div class="description detailed hidden">
			<p>Escapes a column/table/schema name</p>


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$identifier</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					string
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="lastInsertId" id="_lastInsertId">

		<td class="attributes"><code>
			 public 

			integer
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_lastInsertId">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#174-179" title="Go to source code">lastInsertId</a>( )</code>

		<div class="description short">
			<p>Returns insert id for the auto_increment column inserted in the last SQL statement</p>
		</div>

		<div class="description detailed hidden">
			<p>Returns insert id for the auto_increment column inserted in the last SQL statement</p>



				<h4>Returns</h4>
				<div class="list">
					integer
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="begin" id="_begin">

		<td class="attributes"><code>
			 public 

			
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_begin">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#181-186" title="Go to source code">begin</a>( )</code>

		<div class="description short">
			<p>Starts a transaction in the connection</p>
		</div>

		<div class="description detailed hidden">
			<p>Starts a transaction in the connection</p>







		</div>
		</div></td>
	</tr>
	<tr data-order="isUnderTransaction" id="_isUnderTransaction">

		<td class="attributes"><code>
			 public 

			boolean
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_isUnderTransaction">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#188-198" title="Go to source code">isUnderTransaction</a>( )</code>

		<div class="description short">
			<p>Checks whether the connection is under a transaction</p>
		</div>

		<div class="description detailed hidden">
			<p>Checks whether the connection is under a transaction</p>

<pre><span class="php-var">$connection</span>-&gt;begin();
   <span class="php-keyword2">var_dump</span>(<span class="php-var">$connection</span>-&gt;isUnderTransaction()); <span class="php-comment">//true</span></pre>



				<h4>Returns</h4>
				<div class="list">
					boolean
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="rollback" id="_rollback">

		<td class="attributes"><code>
			 public 

			
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_rollback">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#200-205" title="Go to source code">rollback</a>( )</code>

		<div class="description short">
			<p>Rollbacks the active transaction in the connection</p>
		</div>

		<div class="description detailed hidden">
			<p>Rollbacks the active transaction in the connection</p>







		</div>
		</div></td>
	</tr>
	<tr data-order="commit" id="_commit">

		<td class="attributes"><code>
			 public 

			
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_commit">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#207-212" title="Go to source code">commit</a>( )</code>

		<div class="description short">
			<p>Commits the active transaction in the connection</p>
		</div>

		<div class="description detailed hidden">
			<p>Commits the active transaction in the connection</p>







		</div>
		</div></td>
	</tr>
	<tr data-order="getMetadata" id="_getMetadata">

		<td class="attributes"><code>
			 public 

			array
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_getMetadata">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#214-219" title="Go to source code">getMetadata</a>( <span>string <var>$source</var></span> )</code>

		<div class="description short">
			
		</div>

		<div class="description detailed hidden">
			


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$source</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					array
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="truncateTable" id="_truncateTable">

		<td class="attributes"><code>
			 public 

			static
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_truncateTable">#</a>
		<code><a href="source-class-ManaPHP.DbInterface.html#221-226" title="Go to source code">truncateTable</a>( <span>string <var>$source</var></span> )</code>

		<div class="description short">
			
		</div>

		<div class="description detailed hidden">
			


				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$source</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					static
				</div>




		</div>
		</div></td>
	</tr>
	</table>


















</div>

	<div id="footer">
		 API documentation generated by <a href="http://apigen.org">ApiGen</a>
	</div>
</div>
</div>
<script src="resources/combined.js"></script>
<script src="elementlist.js"></script>
</body>
</html>
